Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 331262 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 88200 |
| Duplicate rows (%) | 26.6% |
| Total size in memory | 101.1 MiB |
| Average record size in memory | 320.0 B |
Variable types
| Numeric | 14 |
|---|---|
| Categorical | 4 |
| Unsupported | 3 |
RevisionNumber has constant value "1" | Constant |
OrderQuantity has constant value "1" | Constant |
| Dataset has 88200 (26.6%) duplicate rows | Duplicates |
SalesOrderNumber has a high cardinality: 27659 distinct values | High cardinality |
SaleTypeKey is highly correlated with SalesOrderLineNumber | High correlation |
SalesOrderLineNumber is highly correlated with SaleTypeKey | High correlation |
UnitPrice is highly correlated with ProductStandardCost and 5 other fields | High correlation |
ProductStandardCost is highly correlated with UnitPrice and 5 other fields | High correlation |
TotalProductCost is highly correlated with UnitPrice and 5 other fields | High correlation |
SalesAmount is highly correlated with UnitPrice and 5 other fields | High correlation |
TaxAmt is highly correlated with UnitPrice and 5 other fields | High correlation |
Freight is highly correlated with UnitPrice and 5 other fields | High correlation |
ExtendedAmount is highly correlated with UnitPrice and 5 other fields | High correlation |
RevisionNumber is highly correlated with OrderQuantity and 1 other fields | High correlation |
OrderQuantity is highly correlated with RevisionNumber and 1 other fields | High correlation |
PromotionKey is highly correlated with RevisionNumber and 1 other fields | High correlation |
OrderDate is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
DueDate is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ShipDate is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
UnitPriceDiscountPct has 290427 (87.7%) zeros | Zeros |
Reproduction
| Analysis started | 2021-03-08 02:59:28.280623 |
|---|---|
| Analysis finished | 2021-03-08 03:00:31.756630 |
| Duration | 1 minute and 3.48 seconds |
| Software version | pandas-profiling v2.11.0 |
| Download configuration | config.yaml |
DateKey
Real number (ℝ≥0)
| Distinct | 1123 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20159803.01 |
|---|---|
| Minimum | 20131229 |
| Maximum | 20170128 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 20131229 |
|---|---|
| 5-th percentile | 20150505 |
| Q1 | 20160404 |
| median | 20160714 |
| Q3 | 20161018 |
| 95-th percentile | 20161224 |
| Maximum | 20170128 |
| Range | 38899 |
| Interquartile range (IQR) | 614 |
Descriptive statistics
| Standard deviation | 4624.07144 |
|---|---|
| Coefficient of variation (CV) | 0.0002293708643 |
| Kurtosis | 8.718159645 |
| Mean | 20159803.01 |
| Median Absolute Deviation (MAD) | 307 |
| Skewness | -2.460296333 |
| Sum | 6.678176664 × 1012 |
| Variance | 21382036.68 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 20161212 | 1421 | 0.4% |
| 20161001 | 1358 | 0.4% |
| 20160605 | 1322 | 0.4% |
| 20160819 | 1311 | 0.4% |
| 20161209 | 1308 | 0.4% |
| 20161205 | 1242 | 0.4% |
| 20161017 | 1216 | 0.4% |
| 20161226 | 1213 | 0.4% |
| 20161219 | 1212 | 0.4% |
| 20161215 | 1211 | 0.4% |
| Other values (1113) | 318448 |
| Value | Count | Frequency (%) |
| 20131229 | 25 | |
| 20131230 | 20 | |
| 20131231 | 25 | |
| 20140101 | 10 | < 0.1% |
| 20140102 | 25 | |
| 20140103 | 20 | |
| 20140104 | 15 | |
| 20140105 | 15 | |
| 20140106 | 30 | |
| 20140107 | 15 |
| Value | Count | Frequency (%) |
| 20170128 | 527 | |
| 20170127 | 342 | |
| 20170126 | 387 | |
| 20170125 | 452 | |
| 20170124 | 355 | |
| 20170123 | 415 | |
| 20170122 | 307 | |
| 20170121 | 468 | |
| 20170120 | 389 | |
| 20170119 | 413 |
ProductKey
Real number (ℝ≥0)
| Distinct | 606 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 325.3774233 |
|---|---|
| Minimum | 1 |
| Maximum | 606 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 57 |
| Q1 | 216 |
| median | 324 |
| Q3 | 417 |
| 95-th percentile | 572 |
| Maximum | 606 |
| Range | 605 |
| Interquartile range (IQR) | 201 |
Descriptive statistics
| Standard deviation | 154.0875158 |
|---|---|
| Coefficient of variation (CV) | 0.4735654803 |
| Kurtosis | -0.6406707325 |
| Mean | 325.3774233 |
| Median Absolute Deviation (MAD) | 96 |
| Skewness | -0.3000840847 |
| Sum | 107785176 |
| Variance | 23742.96251 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 303 | 8488 | 2.6% |
| 400 | 8488 | 2.6% |
| 403 | 6382 | 1.9% |
| 306 | 6382 | 1.9% |
| 415 | 6190 | 1.9% |
| 318 | 6190 | 1.9% |
| 319 | 4752 | 1.4% |
| 416 | 4752 | 1.4% |
| 311 | 4523 | 1.4% |
| 557 | 4244 | 1.3% |
| Other values (596) | 270871 |
| Value | Count | Frequency (%) |
| 1 | 2230 | |
| 2 | 2085 | |
| 3 | 2125 | |
| 4 | 2190 | |
| 5 | 429 | 0.1% |
| 6 | 442 | 0.1% |
| 7 | 452 | 0.1% |
| 8 | 413 | 0.1% |
| 9 | 336 | 0.1% |
| 10 | 281 | 0.1% |
| Value | Count | Frequency (%) |
| 606 | 334 | |
| 605 | 232 | |
| 604 | 216 | |
| 603 | 235 | |
| 602 | 246 | |
| 601 | 88 | < 0.1% |
| 600 | 106 | < 0.1% |
| 599 | 97 | < 0.1% |
| 598 | 147 | |
| 597 | 160 |
CustomerKey
Real number (ℝ≥0)
| Distinct | 18484 |
|---|---|
| Distinct (%) | 5.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18860.50353 |
|---|---|
| Minimum | 11000 |
| Maximum | 29483 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 11000 |
|---|---|
| 5-th percentile | 11410.05 |
| Q1 | 14023 |
| median | 18177 |
| Q3 | 23447 |
| 95-th percentile | 28100 |
| Maximum | 29483 |
| Range | 18483 |
| Interquartile range (IQR) | 9424 |
Descriptive statistics
| Standard deviation | 5428.760474 |
|---|---|
| Coefficient of variation (CV) | 0.2878375153 |
| Kurtosis | -1.163990054 |
| Mean | 18860.50353 |
| Median Absolute Deviation (MAD) | 4601 |
| Skewness | 0.276155324 |
| Sum | 6247768121 |
| Variance | 29471440.28 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 11300 | 383 | 0.1% |
| 11185 | 372 | 0.1% |
| 11277 | 365 | 0.1% |
| 11262 | 356 | 0.1% |
| 11287 | 352 | 0.1% |
| 11091 | 335 | 0.1% |
| 11176 | 335 | 0.1% |
| 11331 | 334 | 0.1% |
| 11276 | 321 | 0.1% |
| 11566 | 318 | 0.1% |
| Other values (18474) | 327791 |
| Value | Count | Frequency (%) |
| 11000 | 43 | |
| 11001 | 59 | |
| 11002 | 20 | < 0.1% |
| 11003 | 50 | |
| 11004 | 29 | |
| 11005 | 34 | |
| 11006 | 28 | |
| 11007 | 41 | |
| 11008 | 37 | |
| 11009 | 26 |
| Value | Count | Frequency (%) |
| 29483 | 5 | < 0.1% |
| 29482 | 5 | < 0.1% |
| 29481 | 5 | < 0.1% |
| 29480 | 26 | |
| 29479 | 5 | < 0.1% |
| 29478 | 18 | |
| 29477 | 14 | |
| 29476 | 5 | < 0.1% |
| 29475 | 5 | < 0.1% |
| 29474 | 5 | < 0.1% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.3 MiB |
| 1 | |
|---|---|
| 2 | 11931 |
| 13 | 115 |
| 14 | 78 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.00058262 |
| Min length | 1 |
Characters and Unicode
| Total characters | 331455 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
| Value | Count | Frequency (%) |
| 1 | 319138 | |
| 2 | 11931 | 3.6% |
| 13 | 115 | < 0.1% |
| 14 | 78 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 319138 | |
| 2 | 11931 | 3.6% |
| 13 | 115 | < 0.1% |
| 14 | 78 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 319331 | |
| 2 | 11931 | 3.6% |
| 3 | 115 | < 0.1% |
| 4 | 78 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 331455 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 319331 | |
| 2 | 11931 | 3.6% |
| 3 | 115 | < 0.1% |
| 4 | 78 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 331455 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 1 | 319331 | |
| 2 | 11931 | 3.6% |
| 3 | 115 | < 0.1% |
| 4 | 78 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 331455 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1 | 319331 | |
| 2 | 11931 | 3.6% |
| 3 | 115 | < 0.1% |
| 4 | 78 | < 0.1% |
CurrencyKey
Real number (ℝ≥0)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69.66434122 |
|---|---|
| Minimum | 6 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 19 |
| median | 100 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 94 |
| Interquartile range (IQR) | 81 |
Descriptive statistics
| Standard deviation | 42.20774105 |
|---|---|
| Coefficient of variation (CV) | 0.6058729662 |
| Kurtosis | -1.463107111 |
| Mean | 69.66434122 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.7107491323 |
| Sum | 23077149 |
| Variance | 1781.493405 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 182918 | |
| 6 | 71534 | 21.6% |
| 19 | 39590 | 12.0% |
| 98 | 36545 | 11.0% |
| 29 | 380 | 0.1% |
| 39 | 295 | 0.1% |
| Value | Count | Frequency (%) |
| 6 | 71534 | 21.6% |
| 19 | 39590 | 12.0% |
| 29 | 380 | 0.1% |
| 39 | 295 | 0.1% |
| 98 | 36545 | 11.0% |
| 100 | 182918 |
| Value | Count | Frequency (%) |
| 100 | 182918 | |
| 98 | 36545 | 11.0% |
| 39 | 295 | 0.1% |
| 29 | 380 | 0.1% |
| 19 | 39590 | 12.0% |
| 6 | 71534 | 21.6% |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.853403047 |
|---|---|
| Minimum | 1 |
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.9982626371 |
|---|---|
| Coefficient of variation (CV) | 0.5386106594 |
| Kurtosis | 0.8058291079 |
| Mean | 1.853403047 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.105900491 |
| Sum | 613962 |
| Variance | 0.9965282926 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 156023 | |
| 2 | 98098 | |
| 3 | 52460 | 15.8% |
| 4 | 19846 | 6.0% |
| 5 | 4129 | 1.2% |
| 6 | 620 | 0.2% |
| 7 | 74 | < 0.1% |
| 8 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 156023 | |
| 2 | 98098 | |
| 3 | 52460 | 15.8% |
| 4 | 19846 | 6.0% |
| 5 | 4129 | 1.2% |
| 6 | 620 | 0.2% |
| 7 | 74 | < 0.1% |
| 8 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 8 | 12 | < 0.1% |
| 7 | 74 | < 0.1% |
| 6 | 620 | 0.2% |
| 5 | 4129 | 1.2% |
| 4 | 19846 | 6.0% |
| 3 | 52460 | 15.8% |
| 2 | 98098 | |
| 1 | 156023 |
| Distinct | 27659 |
|---|---|
| Distinct (%) | 8.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.2 MiB |
| SO70714 | 45 |
|---|---|
| SO58845 | 43 |
| SO72656 | 42 |
| SO54784 | 42 |
| SO54042 | 42 |
| Other values (27654) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 2318834 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SO70513 |
|---|---|
| 2nd row | SO70517 |
| 3rd row | SO70586 |
| 4th row | SO70661 |
| 5th row | SO70647 |
| Value | Count | Frequency (%) |
| SO70714 | 45 | < 0.1% |
| SO58845 | 43 | < 0.1% |
| SO72656 | 42 | < 0.1% |
| SO54784 | 42 | < 0.1% |
| SO54042 | 42 | < 0.1% |
| SO51555 | 41 | < 0.1% |
| SO64042 | 41 | < 0.1% |
| SO61412 | 40 | < 0.1% |
| SO60233 | 39 | < 0.1% |
| SO62984 | 39 | < 0.1% |
| Other values (27649) | 330848 |
| Value | Count | Frequency (%) |
| so70714 | 45 | < 0.1% |
| so58845 | 43 | < 0.1% |
| so54784 | 42 | < 0.1% |
| so72656 | 42 | < 0.1% |
| so54042 | 42 | < 0.1% |
| so51555 | 41 | < 0.1% |
| so64042 | 41 | < 0.1% |
| so61412 | 40 | < 0.1% |
| so71961 | 39 | < 0.1% |
| so58572 | 39 | < 0.1% |
| Other values (27649) | 330848 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 331262 | |
| O | 331262 | |
| 6 | 259047 | |
| 5 | 241674 | |
| 7 | 193922 | |
| 4 | 168104 | |
| 2 | 137567 | |
| 3 | 136799 | |
| 1 | 131361 | 5.7% |
| 0 | 130485 | 5.6% |
| Other values (2) | 257351 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1656310 | |
| Uppercase Letter | 662524 | 28.6% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 6 | 259047 | |
| 5 | 241674 | |
| 7 | 193922 | |
| 4 | 168104 | |
| 2 | 137567 | |
| 3 | 136799 | |
| 1 | 131361 | |
| 0 | 130485 | |
| 8 | 129506 | |
| 9 | 127845 |
| Value | Count | Frequency (%) |
| S | 331262 | |
| O | 331262 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1656310 | |
| Latin | 662524 | 28.6% |
Most frequent character per script
| Value | Count | Frequency (%) |
| 6 | 259047 | |
| 5 | 241674 | |
| 7 | 193922 | |
| 4 | 168104 | |
| 2 | 137567 | |
| 3 | 136799 | |
| 1 | 131361 | |
| 0 | 130485 | |
| 8 | 129506 | |
| 9 | 127845 |
| Value | Count | Frequency (%) |
| S | 331262 | |
| O | 331262 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2318834 |
Most frequent character per block
| Value | Count | Frequency (%) |
| S | 331262 | |
| O | 331262 | |
| 6 | 259047 | |
| 5 | 241674 | |
| 7 | 193922 | |
| 4 | 168104 | |
| 2 | 137567 | |
| 3 | 136799 | |
| 1 | 131361 | 5.7% |
| 0 | 130485 | 5.6% |
| Other values (2) | 257351 |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.853403047 |
|---|---|
| Minimum | 1 |
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.9982626371 |
|---|---|
| Coefficient of variation (CV) | 0.5386106594 |
| Kurtosis | 0.8058291079 |
| Mean | 1.853403047 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.105900491 |
| Sum | 613962 |
| Variance | 0.9965282926 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 156023 | |
| 2 | 98098 | |
| 3 | 52460 | 15.8% |
| 4 | 19846 | 6.0% |
| 5 | 4129 | 1.2% |
| 6 | 620 | 0.2% |
| 7 | 74 | < 0.1% |
| 8 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 156023 | |
| 2 | 98098 | |
| 3 | 52460 | 15.8% |
| 4 | 19846 | 6.0% |
| 5 | 4129 | 1.2% |
| 6 | 620 | 0.2% |
| 7 | 74 | < 0.1% |
| 8 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 8 | 12 | < 0.1% |
| 7 | 74 | < 0.1% |
| 6 | 620 | 0.2% |
| 5 | 4129 | 1.2% |
| 4 | 19846 | 6.0% |
| 3 | 52460 | 15.8% |
| 2 | 98098 | |
| 1 | 156023 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.3 MiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 331262 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
| Value | Count | Frequency (%) |
| 1 | 331262 |
| Value | Count | Frequency (%) |
| 1 | 331262 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 331262 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 331262 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 331262 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 331262 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 1 | 331262 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 331262 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1 | 331262 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.3 MiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 331262 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
| Value | Count | Frequency (%) |
| 1 | 331262 |
| Value | Count | Frequency (%) |
| 1 | 331262 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 331262 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 331262 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 331262 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 331262 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 1 | 331262 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 331262 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1 | 331262 |
| Distinct | 133 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 502.3153472 |
|---|---|
| Minimum | 12.99 |
| Maximum | 2899.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 12.99 |
|---|---|
| 5-th percentile | 67.4 |
| Q1 | 219 |
| median | 369 |
| Q3 | 699 |
| 95-th percentile | 1299 |
| Maximum | 2899.99 |
| Range | 2887 |
| Interquartile range (IQR) | 480 |
Descriptive statistics
| Standard deviation | 408.9683636 |
|---|---|
| Coefficient of variation (CV) | 0.8141665706 |
| Kurtosis | 5.756004151 |
| Mean | 502.3153472 |
| Median Absolute Deviation (MAD) | 230 |
| Skewness | 1.894929663 |
| Sum | 166397986.5 |
| Variance | 167255.1224 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 699 | 26363 | 8.0% |
| 758 | 15501 | 4.7% |
| 599 | 15059 | 4.5% |
| 369 | 14837 | 4.5% |
| 869 | 14503 | 4.4% |
| 326 | 12374 | 3.7% |
| 279 | 9134 | 2.8% |
| 299 | 9133 | 2.8% |
| 999 | 9029 | 2.7% |
| 149.99 | 8696 | 2.6% |
| Other values (123) | 196633 |
| Value | Count | Frequency (%) |
| 12.99 | 4315 | |
| 14.52 | 2125 | |
| 21.57 | 3513 | |
| 25.69 | 620 | 0.2% |
| 37.95 | 582 | 0.2% |
| 40.55 | 1458 | 0.4% |
| 47.95 | 463 | 0.1% |
| 49 | 502 | 0.2% |
| 56.9 | 80 | < 0.1% |
| 59 | 649 | 0.2% |
| Value | Count | Frequency (%) |
| 2899.99 | 267 | 0.1% |
| 2499 | 2498 | 0.8% |
| 2295 | 1708 | 0.5% |
| 1592.2 | 5186 | |
| 1299 | 7935 | |
| 1199 | 117 | < 0.1% |
| 1184.97 | 195 | 0.1% |
| 1109 | 688 | 0.2% |
| 1099.99 | 5064 | |
| 1099 | 376 | 0.1% |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.018693662 |
|---|---|
| Minimum | 0 |
| Maximum | 22.5 |
| Zeros | 290427 |
| Zeros (%) | 87.7% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 18 |
| Maximum | 22.5 |
| Range | 22.5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 5.439369563 |
|---|---|
| Coefficient of variation (CV) | 2.694499747 |
| Kurtosis | 3.832743589 |
| Mean | 2.018693662 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.381278229 |
| Sum | 668716.5 |
| Variance | 29.58674124 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 290427 | |
| 18 | 20910 | 6.3% |
| 14 | 14976 | 4.5% |
| 19.5 | 2900 | 0.9% |
| 12.5 | 1998 | 0.6% |
| 22.5 | 51 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 290427 | |
| 12.5 | 1998 | 0.6% |
| 14 | 14976 | 4.5% |
| 18 | 20910 | 6.3% |
| 19.5 | 2900 | 0.9% |
| 22.5 | 51 | < 0.1% |
| Value | Count | Frequency (%) |
| 22.5 | 51 | < 0.1% |
| 19.5 | 2900 | 0.9% |
| 18 | 20910 | 6.3% |
| 14 | 14976 | 4.5% |
| 12.5 | 1998 | 0.6% |
| 0 | 290427 |
| Distinct | 149 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 208.5625904 |
|---|---|
| Minimum | 6.62 |
| Maximum | 960.82 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 6.62 |
|---|---|
| 5-th percentile | 34.36 |
| Q1 | 91.95 |
| median | 169.69 |
| Q3 | 321.05 |
| 95-th percentile | 459.4 |
| Maximum | 960.82 |
| Range | 954.2 |
| Interquartile range (IQR) | 229.1 |
Descriptive statistics
| Standard deviation | 142.5715625 |
|---|---|
| Coefficient of variation (CV) | 0.6835912532 |
| Kurtosis | 2.908754623 |
| Mean | 208.5625904 |
| Median Absolute Deviation (MAD) | 105.77 |
| Skewness | 1.226892581 |
| Sum | 69088860.82 |
| Variance | 20326.65045 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 321.44 | 26363 | 8.0% |
| 348.58 | 15501 | 4.7% |
| 275.46 | 15059 | 4.5% |
| 287.92 | 14503 | 4.4% |
| 166.2 | 12374 | 3.7% |
| 169.69 | 12145 | 3.7% |
| 49.69 | 8696 | 2.6% |
| 430.38 | 7935 | 2.4% |
| 142.24 | 7441 | 2.2% |
| 61.16 | 7283 | 2.2% |
| Other values (139) | 203962 |
| Value | Count | Frequency (%) |
| 6.62 | 4315 | |
| 7.4 | 2125 | |
| 11 | 3513 | |
| 13.1 | 620 | 0.2% |
| 17.45 | 582 | 0.2% |
| 18.65 | 1458 | 0.4% |
| 22.05 | 463 | 0.1% |
| 22.86 | 464 | 0.1% |
| 24.98 | 502 | 0.2% |
| 29.01 | 80 | < 0.1% |
| Value | Count | Frequency (%) |
| 960.82 | 267 | 0.1% |
| 827.97 | 2498 | 0.8% |
| 760.38 | 1708 | 0.5% |
| 527.53 | 5186 | |
| 505.85 | 5064 | |
| 459.4 | 1971 | 0.6% |
| 444.69 | 397 | 0.1% |
| 430.38 | 7935 | |
| 404.63 | 136 | < 0.1% |
| 397.25 | 117 | < 0.1% |
| Distinct | 149 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 208.5625904 |
|---|---|
| Minimum | 6.62 |
| Maximum | 960.82 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 6.62 |
|---|---|
| 5-th percentile | 34.36 |
| Q1 | 91.95 |
| median | 169.69 |
| Q3 | 321.05 |
| 95-th percentile | 459.4 |
| Maximum | 960.82 |
| Range | 954.2 |
| Interquartile range (IQR) | 229.1 |
Descriptive statistics
| Standard deviation | 142.5715625 |
|---|---|
| Coefficient of variation (CV) | 0.6835912532 |
| Kurtosis | 2.908754623 |
| Mean | 208.5625904 |
| Median Absolute Deviation (MAD) | 105.77 |
| Skewness | 1.226892581 |
| Sum | 69088860.82 |
| Variance | 20326.65045 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 321.44 | 26363 | 8.0% |
| 348.58 | 15501 | 4.7% |
| 275.46 | 15059 | 4.5% |
| 287.92 | 14503 | 4.4% |
| 166.2 | 12374 | 3.7% |
| 169.69 | 12145 | 3.7% |
| 49.69 | 8696 | 2.6% |
| 430.38 | 7935 | 2.4% |
| 142.24 | 7441 | 2.2% |
| 61.16 | 7283 | 2.2% |
| Other values (139) | 203962 |
| Value | Count | Frequency (%) |
| 6.62 | 4315 | |
| 7.4 | 2125 | |
| 11 | 3513 | |
| 13.1 | 620 | 0.2% |
| 17.45 | 582 | 0.2% |
| 18.65 | 1458 | 0.4% |
| 22.05 | 463 | 0.1% |
| 22.86 | 464 | 0.1% |
| 24.98 | 502 | 0.2% |
| 29.01 | 80 | < 0.1% |
| Value | Count | Frequency (%) |
| 960.82 | 267 | 0.1% |
| 827.97 | 2498 | 0.8% |
| 760.38 | 1708 | 0.5% |
| 527.53 | 5186 | |
| 505.85 | 5064 | |
| 459.4 | 1971 | 0.6% |
| 444.69 | 397 | 0.1% |
| 430.38 | 7935 | |
| 404.63 | 136 | < 0.1% |
| 397.25 | 117 | < 0.1% |
| Distinct | 250 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 491.1485504 |
|---|---|
| Minimum | 10.6518 |
| Maximum | 2899.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 10.6518 |
|---|---|
| 5-th percentile | 67.4 |
| Q1 | 204.9918 |
| median | 369 |
| Q3 | 699 |
| 95-th percentile | 1099.99 |
| Maximum | 2899.99 |
| Range | 2889.3382 |
| Interquartile range (IQR) | 494.0082 |
Descriptive statistics
| Standard deviation | 402.5377754 |
|---|---|
| Coefficient of variation (CV) | 0.8195845738 |
| Kurtosis | 5.967969403 |
| Mean | 491.1485504 |
| Median Absolute Deviation (MAD) | 230 |
| Skewness | 1.926724007 |
| Sum | 162698851.1 |
| Variance | 162036.6606 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 699 | 23660 | 7.1% |
| 369 | 14187 | 4.3% |
| 599 | 13573 | 4.1% |
| 758 | 13385 | 4.0% |
| 869 | 12831 | 3.9% |
| 326 | 11368 | 3.4% |
| 999 | 8404 | 2.5% |
| 279 | 8115 | 2.4% |
| 299 | 8061 | 2.4% |
| 149.99 | 7482 | 2.3% |
| Other values (240) | 210196 |
| Value | Count | Frequency (%) |
| 10.6518 | 259 | 0.1% |
| 11.9064 | 125 | < 0.1% |
| 12.99 | 4056 | |
| 14.52 | 2000 | |
| 17.6874 | 377 | 0.1% |
| 21.0658 | 93 | < 0.1% |
| 21.57 | 3136 | |
| 25.69 | 527 | 0.2% |
| 31.119 | 81 | < 0.1% |
| 33.251 | 168 | 0.1% |
| Value | Count | Frequency (%) |
| 2899.99 | 198 | 0.1% |
| 2499 | 2380 | 0.7% |
| 2377.9918 | 69 | < 0.1% |
| 2295 | 1534 | 0.5% |
| 2049.18 | 118 | < 0.1% |
| 1881.9 | 174 | 0.1% |
| 1592.2 | 4714 | |
| 1305.604 | 472 | 0.1% |
| 1299 | 6002 | |
| 1199 | 87 | < 0.1% |
| Distinct | 133 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50.23153472 |
|---|---|
| Minimum | 1.299 |
| Maximum | 289.999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1.299 |
|---|---|
| 5-th percentile | 6.74 |
| Q1 | 21.9 |
| median | 36.9 |
| Q3 | 69.9 |
| 95-th percentile | 129.9 |
| Maximum | 289.999 |
| Range | 288.7 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 40.89683636 |
|---|---|
| Coefficient of variation (CV) | 0.8141665706 |
| Kurtosis | 5.756004151 |
| Mean | 50.23153472 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | 1.894929663 |
| Sum | 16639798.65 |
| Variance | 1672.551224 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 69.9 | 26363 | 8.0% |
| 75.8 | 15501 | 4.7% |
| 59.9 | 15059 | 4.5% |
| 36.9 | 14837 | 4.5% |
| 86.9 | 14503 | 4.4% |
| 32.6 | 12374 | 3.7% |
| 27.9 | 9134 | 2.8% |
| 29.9 | 9133 | 2.8% |
| 99.9 | 9029 | 2.7% |
| 14.999 | 8696 | 2.6% |
| Other values (123) | 196633 |
| Value | Count | Frequency (%) |
| 1.299 | 4315 | |
| 1.452 | 2125 | |
| 2.157 | 3513 | |
| 2.569 | 620 | 0.2% |
| 3.795 | 582 | 0.2% |
| 4.055 | 1458 | 0.4% |
| 4.795 | 463 | 0.1% |
| 4.9 | 502 | 0.2% |
| 5.69 | 80 | < 0.1% |
| 5.9 | 649 | 0.2% |
| Value | Count | Frequency (%) |
| 289.999 | 267 | 0.1% |
| 249.9 | 2498 | 0.8% |
| 229.5 | 1708 | 0.5% |
| 159.22 | 5186 | |
| 129.9 | 7935 | |
| 119.9 | 117 | < 0.1% |
| 118.497 | 195 | 0.1% |
| 110.9 | 688 | 0.2% |
| 109.999 | 5064 | |
| 109.9 | 376 | 0.1% |
| Distinct | 133 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 110.5093764 |
|---|---|
| Minimum | 2.8578 |
| Maximum | 637.9978 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 2.8578 |
|---|---|
| 5-th percentile | 14.828 |
| Q1 | 48.18 |
| median | 81.18 |
| Q3 | 153.78 |
| 95-th percentile | 285.78 |
| Maximum | 637.9978 |
| Range | 635.14 |
| Interquartile range (IQR) | 105.6 |
Descriptive statistics
| Standard deviation | 89.97303999 |
|---|---|
| Coefficient of variation (CV) | 0.8141665706 |
| Kurtosis | 5.756004151 |
| Mean | 110.5093764 |
| Median Absolute Deviation (MAD) | 50.6 |
| Skewness | 1.894929663 |
| Sum | 36607557.04 |
| Variance | 8095.147924 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 153.78 | 26363 | 8.0% |
| 166.76 | 15501 | 4.7% |
| 131.78 | 15059 | 4.5% |
| 81.18 | 14837 | 4.5% |
| 191.18 | 14503 | 4.4% |
| 71.72 | 12374 | 3.7% |
| 61.38 | 9134 | 2.8% |
| 65.78 | 9133 | 2.8% |
| 219.78 | 9029 | 2.7% |
| 32.9978 | 8696 | 2.6% |
| Other values (123) | 196633 |
| Value | Count | Frequency (%) |
| 2.8578 | 4315 | |
| 3.1944 | 2125 | |
| 4.7454 | 3513 | |
| 5.6518 | 620 | 0.2% |
| 8.349 | 582 | 0.2% |
| 8.921 | 1458 | 0.4% |
| 10.549 | 463 | 0.1% |
| 10.78 | 502 | 0.2% |
| 12.518 | 80 | < 0.1% |
| 12.98 | 649 | 0.2% |
| Value | Count | Frequency (%) |
| 637.9978 | 267 | 0.1% |
| 549.78 | 2498 | 0.8% |
| 504.9 | 1708 | 0.5% |
| 350.284 | 5186 | |
| 285.78 | 7935 | |
| 263.78 | 117 | < 0.1% |
| 260.6934 | 195 | 0.1% |
| 243.98 | 688 | 0.2% |
| 241.9978 | 5064 | |
| 241.78 | 376 | 0.1% |
| Distinct | 133 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 552.5468819 |
|---|---|
| Minimum | 14.289 |
| Maximum | 3189.989 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 14.289 |
|---|---|
| 5-th percentile | 74.14 |
| Q1 | 240.9 |
| median | 405.9 |
| Q3 | 768.9 |
| 95-th percentile | 1428.9 |
| Maximum | 3189.989 |
| Range | 3175.7 |
| Interquartile range (IQR) | 528 |
Descriptive statistics
| Standard deviation | 449.8651999 |
|---|---|
| Coefficient of variation (CV) | 0.8141665706 |
| Kurtosis | 5.756004151 |
| Mean | 552.5468819 |
| Median Absolute Deviation (MAD) | 253 |
| Skewness | 1.894929663 |
| Sum | 183037785.2 |
| Variance | 202378.6981 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 768.9 | 26363 | 8.0% |
| 833.8 | 15501 | 4.7% |
| 658.9 | 15059 | 4.5% |
| 405.9 | 14837 | 4.5% |
| 955.9 | 14503 | 4.4% |
| 358.6 | 12374 | 3.7% |
| 306.9 | 9134 | 2.8% |
| 328.9 | 9133 | 2.8% |
| 1098.9 | 9029 | 2.7% |
| 164.989 | 8696 | 2.6% |
| Other values (123) | 196633 |
| Value | Count | Frequency (%) |
| 14.289 | 4315 | |
| 15.972 | 2125 | |
| 23.727 | 3513 | |
| 28.259 | 620 | 0.2% |
| 41.745 | 582 | 0.2% |
| 44.605 | 1458 | 0.4% |
| 52.745 | 463 | 0.1% |
| 53.9 | 502 | 0.2% |
| 62.59 | 80 | < 0.1% |
| 64.9 | 649 | 0.2% |
| Value | Count | Frequency (%) |
| 3189.989 | 267 | 0.1% |
| 2748.9 | 2498 | 0.8% |
| 2524.5 | 1708 | 0.5% |
| 1751.42 | 5186 | |
| 1428.9 | 7935 | |
| 1318.9 | 117 | < 0.1% |
| 1303.467 | 195 | 0.1% |
| 1219.9 | 688 | 0.2% |
| 1209.989 | 5064 | |
| 1208.9 | 376 | 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| DateKey | ProductKey | CustomerKey | PromotionKey | CurrencyKey | OrderDate | DueDate | ShipDate | SaleTypeKey | SalesOrderNumber | SalesOrderLineNumber | RevisionNumber | OrderQuantity | UnitPrice | UnitPriceDiscountPct | ProductStandardCost | TotalProductCost | SalesAmount | TaxAmt | Freight | ExtendedAmount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 20161110 | 80 | 21588 | 1 | 100 | 2016-11-10 | 2016-11-22 | 2016-11-17 | 1 | SO70513 | 1 | 1 | 1 | 40.55 | 0.0 | 18.65 | 18.65 | 40.550 | 4.055 | 8.921 | 44.605 |
| 1 | 20161110 | 80 | 24835 | 1 | 98 | 2016-11-10 | 2016-11-22 | 2016-11-17 | 1 | SO70517 | 1 | 1 | 1 | 40.55 | 0.0 | 18.65 | 18.65 | 40.550 | 4.055 | 8.921 | 44.605 |
| 2 | 20161111 | 80 | 21798 | 1 | 100 | 2016-11-11 | 2016-11-23 | 2016-11-18 | 1 | SO70586 | 1 | 1 | 1 | 40.55 | 0.0 | 18.65 | 18.65 | 40.550 | 4.055 | 8.921 | 44.605 |
| 3 | 20161112 | 80 | 21607 | 1 | 100 | 2016-11-12 | 2016-11-24 | 2016-11-19 | 1 | SO70661 | 1 | 1 | 1 | 40.55 | 0.0 | 18.65 | 18.65 | 40.550 | 4.055 | 8.921 | 44.605 |
| 4 | 20161112 | 80 | 26764 | 1 | 6 | 2016-11-12 | 2016-11-24 | 2016-11-19 | 1 | SO70647 | 1 | 1 | 1 | 40.55 | 0.0 | 18.65 | 18.65 | 40.550 | 4.055 | 8.921 | 44.605 |
| 5 | 20161113 | 80 | 21812 | 1 | 100 | 2016-11-13 | 2016-11-25 | 2016-11-20 | 1 | SO70739 | 1 | 1 | 1 | 40.55 | 0.0 | 18.65 | 18.65 | 40.550 | 4.055 | 8.921 | 44.605 |
| 6 | 20161114 | 80 | 17927 | 1 | 6 | 2016-11-14 | 2016-11-26 | 2016-11-21 | 1 | SO70801 | 1 | 1 | 1 | 40.55 | 18.0 | 18.65 | 18.65 | 33.251 | 4.055 | 8.921 | 44.605 |
| 7 | 20161114 | 80 | 20888 | 1 | 100 | 2016-11-14 | 2016-11-26 | 2016-11-21 | 1 | SO70817 | 1 | 1 | 1 | 40.55 | 0.0 | 18.65 | 18.65 | 40.550 | 4.055 | 8.921 | 44.605 |
| 8 | 20161114 | 80 | 21410 | 1 | 100 | 2016-11-14 | 2016-11-26 | 2016-11-21 | 1 | SO70815 | 1 | 1 | 1 | 40.55 | 0.0 | 18.65 | 18.65 | 40.550 | 4.055 | 8.921 | 44.605 |
| 9 | 20161116 | 80 | 27586 | 1 | 6 | 2016-11-16 | 2016-11-28 | 2016-11-23 | 1 | SO70919 | 1 | 1 | 1 | 40.55 | 0.0 | 18.65 | 18.65 | 40.550 | 4.055 | 8.921 | 44.605 |
Last rows
| DateKey | ProductKey | CustomerKey | PromotionKey | CurrencyKey | OrderDate | DueDate | ShipDate | SaleTypeKey | SalesOrderNumber | SalesOrderLineNumber | RevisionNumber | OrderQuantity | UnitPrice | UnitPriceDiscountPct | ProductStandardCost | TotalProductCost | SalesAmount | TaxAmt | Freight | ExtendedAmount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 331252 | 20151015 | 191 | 15862 | 1 | 100 | 2015-10-15 | 2015-10-27 | 2015-10-22 | 1 | SO50073 | 1 | 1 | 1 | 66.0 | 0.0 | 33.65 | 33.65 | 66.0 | 6.6 | 14.52 | 72.6 |
| 331253 | 20151023 | 191 | 26919 | 1 | 6 | 2015-10-23 | 2015-11-04 | 2015-10-30 | 1 | SO50150 | 1 | 1 | 1 | 66.0 | 0.0 | 33.65 | 33.65 | 66.0 | 6.6 | 14.52 | 72.6 |
| 331254 | 20151109 | 191 | 27370 | 1 | 6 | 2015-11-09 | 2015-11-21 | 2015-11-16 | 1 | SO50470 | 1 | 1 | 1 | 66.0 | 0.0 | 33.65 | 33.65 | 66.0 | 6.6 | 14.52 | 72.6 |
| 331255 | 20151110 | 191 | 15893 | 1 | 100 | 2015-11-10 | 2015-11-22 | 2015-11-17 | 1 | SO50478 | 1 | 1 | 1 | 66.0 | 0.0 | 33.65 | 33.65 | 66.0 | 6.6 | 14.52 | 72.6 |
| 331256 | 20151124 | 191 | 15941 | 1 | 100 | 2015-11-24 | 2015-12-06 | 2015-12-01 | 1 | SO50610 | 1 | 1 | 1 | 66.0 | 0.0 | 33.65 | 33.65 | 66.0 | 6.6 | 14.52 | 72.6 |
| 331257 | 20151127 | 191 | 20945 | 1 | 100 | 2015-11-27 | 2015-12-09 | 2015-12-04 | 1 | SO50647 | 1 | 1 | 1 | 66.0 | 0.0 | 33.65 | 33.65 | 66.0 | 6.6 | 14.52 | 72.6 |
| 331258 | 20151128 | 191 | 21669 | 1 | 98 | 2015-11-28 | 2015-12-10 | 2015-12-05 | 1 | SO50765 | 1 | 1 | 1 | 66.0 | 0.0 | 33.65 | 33.65 | 66.0 | 6.6 | 14.52 | 72.6 |
| 331259 | 20151209 | 191 | 15976 | 1 | 100 | 2015-12-09 | 2015-12-21 | 2015-12-16 | 1 | SO50891 | 1 | 1 | 1 | 66.0 | 0.0 | 33.65 | 33.65 | 66.0 | 6.6 | 14.52 | 72.6 |
| 331260 | 20151218 | 191 | 27472 | 1 | 6 | 2015-12-18 | 2015-12-30 | 2015-12-25 | 1 | SO50993 | 1 | 1 | 1 | 66.0 | 0.0 | 33.65 | 33.65 | 66.0 | 6.6 | 14.52 | 72.6 |
| 331261 | 20151226 | 191 | 15992 | 1 | 100 | 2015-12-26 | 2016-01-07 | 2016-01-02 | 1 | SO51067 | 1 | 1 | 1 | 66.0 | 0.0 | 33.65 | 33.65 | 66.0 | 6.6 | 14.52 | 72.6 |
Most frequent
| DateKey | ProductKey | CustomerKey | PromotionKey | CurrencyKey | SaleTypeKey | SalesOrderNumber | SalesOrderLineNumber | RevisionNumber | OrderQuantity | UnitPrice | UnitPriceDiscountPct | ProductStandardCost | TotalProductCost | SalesAmount | TaxAmt | Freight | ExtendedAmount | count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 20141229 | 274 | 15460 | 1 | 100 | 1 | SO46677 | 1 | 1 | 1 | 399.0 | 0.0 | 183.49 | 183.49 | 399.0 | 39.9 | 87.78 | 438.9 | 2 |
| 1 | 20141229 | 274 | 21193 | 1 | 6 | 1 | SO46680 | 1 | 1 | 1 | 399.0 | 0.0 | 183.49 | 183.49 | 399.0 | 39.9 | 87.78 | 438.9 | 2 |
| 2 | 20141229 | 276 | 13062 | 1 | 100 | 1 | SO46679 | 1 | 1 | 1 | 529.0 | 0.0 | 243.27 | 243.27 | 529.0 | 52.9 | 116.38 | 581.9 | 2 |
| 3 | 20141229 | 288 | 18047 | 1 | 100 | 1 | SO46676 | 1 | 1 | 1 | 199.0 | 0.0 | 101.46 | 101.46 | 199.0 | 19.9 | 43.78 | 218.9 | 2 |
| 4 | 20141229 | 371 | 15460 | 1 | 100 | 1 | SO46677 | 1 | 1 | 1 | 599.0 | 0.0 | 275.46 | 275.46 | 599.0 | 59.9 | 131.78 | 658.9 | 2 |
| 5 | 20141229 | 371 | 21193 | 1 | 6 | 1 | SO46680 | 1 | 1 | 1 | 599.0 | 0.0 | 275.46 | 275.46 | 599.0 | 59.9 | 131.78 | 658.9 | 2 |
| 6 | 20141229 | 373 | 13062 | 1 | 100 | 1 | SO46679 | 1 | 1 | 1 | 326.0 | 0.0 | 166.20 | 166.20 | 326.0 | 32.6 | 71.72 | 358.6 | 2 |
| 7 | 20141229 | 385 | 18047 | 1 | 100 | 1 | SO46676 | 1 | 1 | 1 | 326.0 | 0.0 | 166.20 | 166.20 | 326.0 | 32.6 | 71.72 | 358.6 | 2 |
| 8 | 20141230 | 280 | 12947 | 1 | 100 | 1 | SO46685 | 1 | 1 | 1 | 329.0 | 0.0 | 167.73 | 167.73 | 329.0 | 32.9 | 72.38 | 361.9 | 2 |
| 9 | 20141230 | 284 | 18125 | 1 | 100 | 1 | SO46684 | 1 | 1 | 1 | 489.0 | 0.0 | 224.87 | 224.87 | 489.0 | 48.9 | 107.58 | 537.9 | 2 |